package com.ericsson.resourceplanner.dao.entity;

import java.io.Serializable;
import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.IdClass;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

import org.hibernate.annotations.Immutable;

@Entity
@Table(name="V_REPORT")
@Immutable
@NamedQuery(name="getReportForDates",query="select e from Report e where e.startDate>= :startDate and e.endDate <= :endDate" )
@IdClass(value=Report.class)
public class Report implements Serializable{
	@Id
	private String signum;
	@Id
	private String empName;
	private String domain;
	private String region;
	private String project;
	private String customer;
	private String ICRRB;
	private String w1;
	private String w2;
	private String w3;
	private String w4;
	private String status;
	private String utilPercent;
	@Temporal(TemporalType.DATE)
	@Column(name="START_DATE")
	private Date startDate;
	@Temporal(TemporalType.DATE)
	@Column(name="END_DATE")
	private Date endDate;
	
	public String getSignum() {
		return signum;
	}
	public void setSignum(String signum) {
		this.signum = signum;
	}
	public String getEmpName() {
		return empName;
	}
	public void setEmpName(String empName) {
		this.empName = empName;
	}
	public String getDomain() {
		return domain;
	}
	public void setDomain(String domain) {
		this.domain = domain;
	}
	public String getRegion() {
		return region;
	}
	public void setRegion(String region) {
		this.region = region;
	}
	public String getProject() {
		return project;
	}
	public void setProject(String project) {
		this.project = project;
	}
	public String getCustomer() {
		return customer;
	}
	public void setCustomer(String customer) {
		this.customer = customer;
	}
	public String getICRRB() {
		return ICRRB;
	}
	public void setICRRB(String iCRRB) {
		ICRRB = iCRRB;
	}
	
	public String getW1() {
		return w1;
	}
	public void setW1(String w1) {
		this.w1 = w1;
	}
	public String getW2() {
		return w2;
	}
	public void setW2(String w2) {
		this.w2 = w2;
	}
	public String getW3() {
		return w3;
	}
	public void setW3(String w3) {
		this.w3 = w3;
	}
	public String getW4() {
		return w4;
	}
	public void setW4(String w4) {
		this.w4 = w4;
	}
	public String getStatus() {
		return status;
	}
	public void setStatus(String status) {
		this.status = status;
	}
	public String getUtilPercent() {
		return utilPercent;
	}
	public void setUtilPercent(String utilPercent) {
		this.utilPercent = utilPercent;
	}
	
	
}
